%%%%%%%%%%%%%%% PUBLICATIONS %%%%%%%%%%%%%%%%%%%

%%%%%%%%%%%%%%% To Appear %%%%%%%%%%%%%%%%%%%
<!--sql
   SELECT PubsJournals.Title, PubsJournals.Authors, PubsJournals.Status,
          Format$(PubsJournals.Date,'mmm yyyy') AS formDate,
          PubsJournals.WWW, PubsJournals.JournalName
   FROM PubsJournals
   WHERE ((PubsJournals.Status)='Accepted' )
   ORDER BY PubsJournals.Date DESC;
##sql
   title_string=``${Title}''
   journal_string= to appear in {\em ${JournalName}}
##sql
   \item
   ${Authors},
   ${title_string}
   ${journal_string}.

sql-->

%%%%%%%%%%%%%%% Published %%%%%%%%%%%%%%%%%%%
<!--sql

   SELECT PubsJournals.Title, PubsJournals.Authors, PubsJournals.Status,
          Format$(PubsJournals.Date,'mmm yyyy') AS formDate,
          PubsJournals.WWW, PubsJournals.JournalName, PubsJournals.Volume, PubsJournals.Number,
          PubsJournals.Pages
   FROM PubsJournals
   WHERE ((PubsJournals.Status)='Published' )
   ORDER BY PubsJournals.Date DESC;
##sql
   title_string=``${Title}''
   journal_string=, {\em ${JournalName}}
   volume_string=, Volume ${Volume}
   number_string=, Number ${Number}
   date_string=, ${formDate}
   pages_string=, pages ${Pages}
##sql
   \item
   ${Authors},${title_string}${journal_string}${volume_string}${number_string}${date_string}${pages_string}.

sql-->
\end{itemize}


\paragraph{Papers in Refereed Conference Proceedings}

%%%%%%%%%%%%%%% To Appear %%%%%%%%%%%%%%%%%%%
\begin{itemize}
  <!--sql
SELECT PubsConferences.ID, PubsConferences.Title,
PubsConferences.Authors, PubsConferences.Status,
Format$(PubsConferences.Date,'mmm yyyy') AS formDate,
PubsConferences.WWW, PubsConferences.ProceedingsTitle,
PubsConferences.Editor, PubsConferences.Location,
PubsConferences.Series, PubsConferences.Volume,
PubsConferences.Number, PubsConferences.publisher,
PubsConferences.Pages FROM PubsConferences WHERE
((PubsConferences.Status)='Accepted') ORDER BY
PubsConferences.Date DESC;

##sql

   title_string=``${Title}''
   conference_string= to appear in {\em ${ProceedingsTitle}}
   date_string=, ${formDate}

   ##sql

   \item
   ${Authors},
   ${title_string}
   ${conference_string}${date_string}.

   sql-->

%%%%%%%%%%%%%%% Published %%%%%%%%%%%%%%%%%%%
  <!--sql
SELECT PubsConferences.ID, PubsConferences.Title,
PubsConferences.Authors, PubsConferences.Status,
Format$(PubsConferences.Date,'mmm yyyy') AS formDate,
PubsConferences.WWW, PubsConferences.ProceedingsTitle,
PubsConferences.Editor, PubsConferences.Location,
PubsConferences.Series, PubsConferences.Volume,
PubsConferences.Number, PubsConferences.publisher,
PubsConferences.Pages FROM PubsConferences WHERE
((PubsConferences.Status)='Published') ORDER BY
PubsConferences.Date DESC;

   ##sql

   title_string=``${Title}''
   conference_string= in {\em ${ProceedingsTitle}}
   volume_string=, Volume ${Volume}
   number_string=, Number ${Number}
   series_string=, ${Series}
   publisher_string=, ${Publisher}
   editor_string=, Eds. ${Editor}
   pages_string=, pages ${Pages}
   location_string=, ${Location}
   date_string=, ${formDate}

   ##sql

   \item
   ${Authors},
   ${title_string}
   ${conference_string}${volume_string}${number_string}${series_string}${publisher_string}${editor_string}${pages_string}${location_string}${date_string}.

   sql-->
